Advanced Settings

Customize connection options according to your needs. The detailed description is given below:

Settings Save Path
When a new connection being established, Navicat will create a subfolder under the Settings Save Path. Most files are stored within this subfolder:

Navicat Objects
Server Type
File Extensions
Query All .sql
Query Builder All .qbs - stores the layout of tables in Query Builder.
Import Wizard Profile MySQL .npi
Oracle .nopi
PostgreSQL .nppi
SQLite .nlpi
SQL Server .nmpi
Export Wizard Profile MySQL .npe
Oracle .nope
PostgreSQL .nppe
SQLite .nlpe
SQL Server .nmpe
Export Query Result Profile MySQL .npeq
Oracle .nopeq
PostgreSQL .nppeq
SQLite .nlpeq
SQL Server .nmpeq
Export View Result Profile MySQL .npev
Oracle .nopev
PostgreSQL .nppev
SQLite .nlpev
SQL Server .nmpev
Export Materialized View Profile Oracle .nopem
Backup MySQL, PostgreSQL and SQLite .pmb

Other files are located in the default folder, e.g. ~/Library/Application Support/Navicat Premium. You are allowed to change location under Preferences.

Other Files
File Extensions
Virtual Grouping vgroup.xml - stores how the objects are categorized.

Hint: All your connection settings and other profiles are stored in Property List file.

See also:
Log Files

MySQL and PostgreSQL

Keepalive interval (sec)
This option allows you to keep the connection with the server alive by pinging it. You can set the period between pings in the edit field.

Auto connect
With this option on, Navicat automatically opens connection with the registered database at application startup.

Use socket file
With this option on, Navicat uses socket file for localhost connection.

Oracle and SQL Server

Keepalive interval (sec)
This option allows you to keep the connection with the server alive by pinging it. You can set the period between pings in the edit field.

Auto connect
With this option on, Navicat automatically opens connection with the registered database at application startup.

SQLite

Auto connect
With this option on, Navicat automatically opens connection with the registered database at application startup.

Encrypted
Enable this option and provide Password when connecting to an encrypted SQLite database.

Attached Databases
To attach or detach databases in the connection.


See also:
Database Management for MySQL Schema Management for Oracle Database Management for PostgreSQL Database Management for SQLite Database Management for SQL Server